using System;
using System.Collections.Generic;
using System.Text;

namespace Common.DbConstants
{
    public struct DbStoredProcedures
    {
        public const string PATIENT_SEARCHVISITS = "[usp.PMS.SearchVisits]";
        public const string PATIENT_ADDVISITS = "[usp.PMS.AddVisits]";
    }
    public struct DbParameters
    {       
        public const string SESSIONID = "@SessionId";
        public const string ERRORMESSAGE = "@ErrorMessage";
        public const string SUCCESSMESSAGE = "@SuccessMessage";
        public const string IDENTITY = "@IDENTITY";
        public const string PATIENTID = "@PatientId";
        public const string VISITDATE = "@VisitDate";
        public const string VISITID = "@VisitId";   
        public const string NOTEID = "@NoteId";
        public const string NOTE = "@Note";
        public const string NOTESTATUSID = "@NoteStatusId";
        
    }

    public struct DbColumnNames
    {
        public const string VISITDATE = "VisitDate";
        public const string PATIENTID = "PatientId";
        public const string VISITID = "VisitId";
        public const string ID = "Id";
        public const string Note = "Note";
        public const string NoteStatusId = "NoteStatusId";

        public const string CREATEDBY = "CreatedBy";
        public const string UPDATEDON = "UpdatedOn";
        public const string UPDATEDBY = "UpdatedBy";
        public const string CREATEDON = "CreatedOn";
    }

    public struct DbColumnNameVisit
    {
        public const string APPOINTMENTSTARTDATE = "AppointmentStartDate";
        public const string VISITID = "VisitId";
        public const string VISITSTATUSNAME = "VisitStatusName";
        public const string VISITSTATUSID = "VisitStatusId";
        public const string VISITISACTIVE = "VisitIsActive";
    }
}
